2015-04-15 - 18537 - Spec - SL100 (EMEA) - Remove Proforma Customers #CrystalReportDevelopment
SPECIFICATIONS
18537 - SL100 (EMEA) - Remove Proforma Customers
Requirement Summary
Need to exclude the EMEA proforma customers from the EMEA version of the SL100 Query & save it as SL100 - EMEA proforma Report.
Admin Info
Purpose
|
Need to remove EMEA proforma customers from the EMEA version of the SL100 report.
|
Requested By
|
Pierre Pazgrat
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
15/04/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
Z_SSL03_TEMP1
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
02
|
2
|
Documentation
|
02
|
3
|
Development/ Config
|
04
|
|
TOTAL
|
08
|
References
Prior Tickets
None
Documents
List of Proforma Customers to be excluded for EMEA region are attached here:
EMEA - Proforma Customers.xlsx
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to create a new BEx Query similar to the EMEA version of SL100 & exclude the attached above proforma customers in the BEx Query & create one time crystal report.
In Scope:
In Addition to the intercompany customers, the specified customers must be excluded in the BEx Query.
Out of Scope:
Transport request is not needed, since BEx Query is created directly in the BPP(BW 7.3 production) by using copy option.
Solution Summary
1. Need to create a new BEx Query similar to the EMEA version SL100 & exclude the attached above proforma customers in the BEx Query.
2. Need to create the crystal report & point it to the new BEx Query created.
3. Need to split the customers & exclude half of them in the filters section and another half in default values section.
Solution Details
1. Need to create a new BEx Query Z_SSL03_TEMP1 similar to EMEA version SL100 query Z_SSL03_Q001 & exclude the attached above proforma customers in the BEx Query.
2. Need to create the crystal report "SL100 - Sales Order Service Level by Sales Org, Routing, Customer and Order Type" same as EMEA version of SL100 report & point it to the new BEx Query Z_SSL03_TEMP1
created.
3. Need to split the customers & exclude half of them in the filters section and another half in default values section.
Issues
All Customers cannot be excluded from Filter section alone since it will not accept filter conditions with size greater than 28KB.